﻿
CREATE PROCEDURE [dbo].[usp_insert_UserSetting]
(
	@username varchar(4000),
	@settingname varchar(4000),
	@settingvalue varchar(4000)
)
AS

SET NOCOUNT ON;
BEGIN TRANSACTION;

delete from UserSetting where username = @username and settingname = @settingname;
insert usersetting(username, settingname, settingvalue) values(@username, @settingname, @settingvalue);

COMMIT TRANSACTION;
SET NOCOUNT OFF;
